Duplicate-Free Generation of Alternatives in Transformation-Based Optimizers
نویسندگان
چکیده
Transformation-based optimizers that explore a search space exhaustively usually apply all possible transformation rules on each alternative, and stop when no new information is produced. In general, diierent sequences of transformation rules may end up deriving the same element. The optimizer must detect and discard these duplicate elements generated by multiple paths. In this paper we consider two questions: How bad is the overhead of duplicate generation? And then, how can it be avoided? We use a restricted class of join reordering to illustrate the problem. For the rst question, our analysis shows that as queries get larger, the number of duplicates is several times that of the new elements. And even for small queries, duplicates are generated more often than new elements. For the second question, we describe a technique to avoid generating duplicates , based on keeping track of (a summary of) the derivation history of each element.
منابع مشابه
RAPPORT Complexity of transformation - based optimizers and duplicate - free generation of alternatives
Transformation-based optimizers that explore a search space exhaustively usually apply all possible transformation rules on each alternative, and stop when no new information is produced. In general, diierent sequences of transformations may end up deriving the same element. The optimizer must detect and discard these duplicate elements. In this paper we consider two questions: How many duplica...
متن کاملOptimizing Join Enumeration in Transformation-based Query Optimizers
Query optimizers built on the Volcano/Cascades framework, which is based on transformation rules, are used in many commercial databases. Transformation rulesets proposed earlier for join order enumeration in such a framework either allow enumeration of joins with cross-products (which can significantly increase the cost of optimization), or generate a large number of duplicate derivations. In t...
متن کاملGreen Energy Generation in Buildings: Grid-Tied Distributed Generation Systems (DGS) With Energy Storage Applications to Sustain the Smart Grid Transformation
The challenge of electricity distribution’s upgrade to incorporate new technologies is big, and electric utilities are mandated to work diligently on this agenda, thus making investments to ensure that current networks maintain their electricity supply commitments secure and reliable in face of disruptions and adverse environmental conditions from a variety of sources. The paper presents a new ...
متن کاملThe Complexity of Transformation-Based Join Enumeration
Query optimizers that explore a search space exhaustively using transformation rules usually apply all possible rules on each alternative, and stop when no new information is produced. A memoizing structure was proposed in [McK93] to improve the re-use of common subexpression, thus improving the efficiency of the search considerably. However, a question that remained open is, what is the comple...
متن کاملHeat generation and radiation effects on steady MHD free convection flow of micropolar fluid past a moving surface
This paper was concerned with studying the magnetohydrodynamic steady laminar free convection flow of a micropolar fluid past a continuously moving surface in the presence of heat generation and thermal radiation. Similarity transformation was employed to transform the governing partial differential equations into ordinary ones, which were then solved numerically using the finite element method...
متن کامل